#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
Created on Wed May  4 11:22:43 2022

@author: cythnia
"""

import pandas as pd
import numpy as np
import pandas_bokeh
data=pd.read_excel('/Users/cythnia/Desktop/猎聘生信工程师招聘信息.xlsx')
data
data['工作地点']=data['工作地点'].str.split('-').str[0]
data1=data.groupby('工作地点').agg({'工作地点':'count'})
data1.column=['地点','数量']
data1
#bokeh作图
data1.plot_bokeh.bar(color='#8ac4dD')
#薪资分类
data2=data.groupby('薪资待遇').agg({'薪资待遇':'count'})
data2
data2.plot_bokeh.bar(color='#8ac4dD')
